<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*, Database.DBConnection"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">





<jsp:include page="t_header.jsp" />

<!--  <div class="breadcrumbs_container">
	<article class="breadcrumbs"> <a href="QM_qualitymanual.jsp">Quality
		Manual</a>
	<div class="breadcrumb_divider"></div>
	<a class="current">Deviation Notes</a> </article>
</div> -->
<jsp:include page="header.html" />

<!-- Declare sidebar -->
<jsp:include page="t_sidebartry.jsp" />

<!-- Main Content -->
<body>
	<section id="main" class="column">

	<div style="margin-top: 4%; margin-left: 25%">
		<table class="tablesorter tableproccess" border="0" cellspacing="0"
			style="width: 80%">

			<tr>
				<td class="blueprocessheader">
					<h2 class="blueprocessh1">Deviation Notes</h2>
				</td>
			</tr>
			<%
				try {
					Connection connection1st = null;
					Statement statement1st = null;
					ResultSet rs1st = null;
					connection1st = DBConnection.connect(true);
					statement1st = connection1st.createStatement(
							ResultSet.TYPE_SCROLL_INSENSITIVE,
							ResultSet.CONCUR_READ_ONLY);
					String QueryString1st = "SELECT * from qmsdb.deviationnotes";
					rs1st = statement1st.executeQuery(QueryString1st);

					while (rs1st.next()) {
			%>
			<tr>
				<td class="oddproccessth"><a
					href="<%=rs1st.getString("DNoteURL")%>" target="_blank"><%=rs1st.getString("DNoteName")%></a>
				</td>
			</tr>
			<%
				}

					// close all the connections.
					rs1st.close();
					statement1st.close();
					connection1st.close();
				}

				catch (Exception ex) {
				} finally {

				}
			%>

		</table>
	</div>
	</section>

	<div class="spacer"></div>


	<!-- Declare closing tags -->
	<jsp:include page="t_footer.jsp" />